package com.api.project.mapper;

import com.api.apicommon.model.entity.UserInterfaceInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**
* @author 小汤圆
* @description 针对表【user_interface_info(用户调用接口关系表)】的数据库操作Mapper
* @createDate 2024-08-11 20:18:25
* @Entity generator.domain.UserInterfaceInfo
*/
public interface UserInterfaceInfoMapper extends BaseMapper<UserInterfaceInfo> {
    //-- 获取接口调用次数的统计信息，并按照调用总次数降序排列，最后取前三个接口作为结果
    //SELECT interfaceInfoId, SUM(totalNum) AS totalNum
    //FROM user_interface_info
    //GROUP BY interfaceInfoId
    //ORDER BY totalNum DESC
    //LIMIT 3;
    List<UserInterfaceInfo> listTopInvokeInterfaceInfo(int limit);
}




